We had 36 auto brands from data source and 35 of them exist in our brand data (except for Ram). But there were two more brands that doesn’t have any request information from May to July(maserati and Alfa romeo), so the total number of brands analyzed here is 33.

Firstly, I counted each uid per day as one visit no matter how many requests the uid have for that day. Last time, I counted each uid one time per hour. As a result, the correlation between monthly visit count and monthly sale is increased to 0.8751 from 0.8585.

cor(all.visit, all.sale) #0.8750606
## [1] 0.8750606

As we have fluctuating number of requests(thus visit) each month, I used visit share(the number of visit for each brand divided by the visit for all the auto companies) as an alternative. So here, I looked at the relationship between monthly visit share and monthly sale for each companies. The correlation of that is higher(0.8818) than the correlation between visit and sale(0.8751).

cor(all.visitshare, all.sale) #0.8818016
## [1] 0.8818016

And I also look at monthly visits only from ‘Weekend’ as weekend visits are more likely connected to sale while visits on weekdays may be more related to repair or other services. I normalized the weekend visits by the number of weekend dates for each month. So the correlation here is 0.8797, which is slightly higher than that of sales and visits(weekday + weekend) of 0.8751.

cor(all.weekendvisit, all.sale) # 0.8797091
## [1] 0.8797091

Now I computed weekend visit’s share for each companies, and the relationship between weekend visit share and monthly sale was 0.8872, which is the highest value so far.

cor(all.weekendvisitshare, all.sale) #0.8871562
## [1] 0.8871562

As we saw last time, here is a graph of sales vs. weekend visits for Luxury brands and Non-luxury brands. We can still see different patterns for luxury brands and non-luxury brands. Luxury brands have relatively smaller visits and higher visits for them doesn’t necessarily indicate higher sales when compared to non-luxury brands.

Luxury brands here : [ “BMW”, “Mercedes”, “Lexus”, “Audi”, “Cadillac”, “Acura”, “Infiniti”, “Lincoln”, “Volvo”, “Land Rover”, “Porsche”, “Jaguar”, “Maserati”, “Bentley”, “Buick”, “Chrysler”]

However, in our data, it doesn’t seem that visit share is related to sales as high as we expected. Below two graphs show Sales(left) and VisitShare(right) for luxury brands. We can see that signs of changes in visit is not always same as the signs of changes in sales. Here, only cadillac’s visitshare shows similar pattern to sales.

For non-luxury brands below, Chevrolet, Honda, Jeep and Mazda shows similar patterns in sales and visits.

And I wondered if there is any distinction between big sales brand and low sales brand as guessed big sales brands might have higher visits and thus stable patterns. Below six graphs are for higher sales brands and they are for monthly sales, monthly visits, monthly visitshares, (monthly sales again for better comparison horizantally), weekend visits, and weekend visitshares, respectively. I can see that visitshare(fig13) shows more similar pattern to monthly sale(fig11) than just visit(fig12) for Chevrolet, Honda and Toyota. Weekend-visitShare(fig15) also improves weekend-visit(fig14), especially for Chevrolet, Jeep, and Nissan.

## The following objects are masked _by_ .GlobalEnv:
## 
##     all.isLux, all.marketshare, all.req, all.sale, all.visit, all.visitshare, all.weekendvisit, all.weekendvisitshare, brand_name

For lower sales brands, Mazda and Cadillac showed more similar pattern to sales after converting to weekend-visitshare.

Below, I attached all the brands’ sales, visitshare, weekendvisitshare graphs for better looking. We can double check that weekend-visitshare can be a good representative of sales for Cadillac, Chevrolet, Jeep, Nissan, and Mazda.

Conclusion : I could find weekend-visit-share shows higher correlation to sale for some auto companies, especially Chevrolet and Mazda. I expected visit-share or weekend-visit-share would show much higher relationship to sales than this result, but many of brands still show different patterns between their visit-share and sales. It indicates not only the total number of request fluctuates, but also the composition of our requests fluctuates. Or there may be some unreliable source in the auto data sales. We need to further look at the data for longer periods.